USE [main]
GO

/****** Object:  Table [dbo].[main_data]    Script Date: 11/03/2011 13:43:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[main_data](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nchar](56) NOT NULL,
	[Country] [nchar](56) NULL,
	[City] [nchar](56) NULL,
	[Address] [nchar](56) NULL,
	[Phone] [nchar](56) NULL,
	[Fax] [nchar](56) NULL,
	[email] [nchar](56) NULL,
	[web_site] [nchar](56) NULL,	
	[LogoLink] [nchar](24) NULL, 
	[Creator] [int] NOT NULL,
	[created] [datetime] NOT NULL 
) ON [PRIMARY] 

GO

ALTER TABLE [dbo].[main_data] ADD  CONSTRAINT [DF_main_data_Creator]  DEFAULT ((0)) FOR [Creator]
GO

